CREATE TABLE [dbo].[TCCLAS_SUBR]
(
[CO_EMPR] [dbo].[TD_VC_002] NOT NULL,
[CO_ARUB] [dbo].[TD_VC_003] NOT NULL,
[CO_RUBR] [dbo].[TD_VC_003] NOT NULL,
[CO_CLSU] [dbo].[TD_VC_003] NOT NULL,
[DE_CLSU] [dbo].[TD_VC_100] NULL,
[NU_ORDE] [dbo].[TD_IN_001] NULL,
[ST_AGRU_CLSU] [dbo].[TD_VC_001_SINO] NULL CONSTRAINT [DF__TCCLAS_SU__ST_AG__0A9D95DB] DEFAULT ('N'),
[ST_SALD_INIC] [dbo].[TD_VC_001_SINO] NULL CONSTRAINT [DF__TCCLAS_SU__ST_SA__0B91BA14] DEFAULT ('N'),
[ST_VALO_DIGI] [dbo].[TD_VC_001] NOT NULL CONSTRAINT [DF__TCCLAS_SU__ST_VA__0C85DE4D] DEFAULT ('N'),
[FA_UNIC] [dbo].[TD_NU_015_006] NULL CONSTRAINT [DF__TCCLAS_SU__FA_UN__0D7A0286] DEFAULT ((0)),
[ST_SALD_12UM] [dbo].[TD_VC_001_SINO] NULL CONSTRAINT [DF__TCCLAS_SU__ST_SA__0E6E26BF] DEFAULT ('N'),
[ST_SALD_06UM] [dbo].[TD_VC_001_SINO] NULL CONSTRAINT [DF__TCCLAS_SU__ST_SA__0F624AF8] DEFAULT ('N'),
[NU_ME01] [dbo].[TD_IN_001] NOT NULL,
[NU_ME02] [dbo].[TD_IN_001] NOT NULL,
[ST_FACT_ANUA] [dbo].[TD_VC_001_SINO] NULL CONSTRAINT [DF__TCCLAS_SU__ST_FA__10566F31] DEFAULT ('N'),
[FA_ANUA] [dbo].[TD_NU_015_006] NULL,
[CO_USUA_CREA] [dbo].[TD_VC_008_USUA] NULL CONSTRAINT [DF__TCCLAS_SU__CO_US__114A936A] DEFAULT (suser_sname()),
[FE_USUA_CREA] [dbo].[TD_DT_001_SIST] NULL CONSTRAINT [DF__TCCLAS_SU__FE_US__123EB7A3] DEFAULT (getdate()),
[CO_USUA_MODI] [dbo].[TD_VC_008_USUA] NULL CONSTRAINT [DF__TCCLAS_SU__CO_US__1332DBDC] DEFAULT (suser_sname()),
[FE_USUA_MODI] [dbo].[TD_DT_001_SIST] NULL CONSTRAINT [DF__TCCLAS_SU__FE_US__14270015] DEFAULT (getdate())
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[TCCLAS_SUBR] ADD CONSTRAINT [PK__TCCLAS_S__19F36B7E00F4FB67] PRIMARY KEY CLUSTERED  ([CO_EMPR], [CO_ARUB], [CO_RUBR], [CO_CLSU]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[TCCLAS_SUBR] ADD CONSTRAINT [FK__TCCLAS_SUBR__7CDA51C0] FOREIGN KEY ([CO_EMPR], [CO_ARUB], [CO_RUBR]) REFERENCES [dbo].[TTRUBR_FINA] ([CO_EMPR], [CO_ARUB], [CO_RUBR])
GO
